package com.sce.core.jpa;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import com.sce.core.entity.UserEntity;

public interface UserJPA extends JpaRepository<UserEntity,String>{
	
	@Query(value="select * from t_user  where LOWER(username) = LOWER(:username)",nativeQuery=true)
	UserEntity findByUserEntityNameCaseInsensitive(@Param("username") String username);

}
